package com.deyuanyun.pic.pipe.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PipeSegmentInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PipeSegmentInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNull() {
            addCriterion("CREATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNotNull() {
            addCriterion("CREATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkEqualTo(String value) {
            addCriterion("CREATE_REMARK =", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotEqualTo(String value) {
            addCriterion("CREATE_REMARK <>", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThan(String value) {
            addCriterion("CREATE_REMARK >", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK >=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThan(String value) {
            addCriterion("CREATE_REMARK <", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK <=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLike(String value) {
            addCriterion("CREATE_REMARK like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotLike(String value) {
            addCriterion("CREATE_REMARK not like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIn(List<String> values) {
            addCriterion("CREATE_REMARK in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotIn(List<String> values) {
            addCriterion("CREATE_REMARK not in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK not between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNull() {
            addCriterion("UPDATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNotNull() {
            addCriterion("UPDATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkEqualTo(String value) {
            addCriterion("UPDATE_REMARK =", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotEqualTo(String value) {
            addCriterion("UPDATE_REMARK <>", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThan(String value) {
            addCriterion("UPDATE_REMARK >", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK >=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThan(String value) {
            addCriterion("UPDATE_REMARK <", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK <=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLike(String value) {
            addCriterion("UPDATE_REMARK like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotLike(String value) {
            addCriterion("UPDATE_REMARK not like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIn(List<String> values) {
            addCriterion("UPDATE_REMARK in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotIn(List<String> values) {
            addCriterion("UPDATE_REMARK not in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK not between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("DELETED is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("DELETED =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("DELETED <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("DELETED >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETED >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("DELETED <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("DELETED <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("DELETED in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("DELETED not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("DELETED between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("DELETED not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNull() {
            addCriterion("VSERSION is null");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNotNull() {
            addCriterion("VSERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVsersionEqualTo(Short value) {
            addCriterion("VSERSION =", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotEqualTo(Short value) {
            addCriterion("VSERSION <>", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThan(Short value) {
            addCriterion("VSERSION >", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThanOrEqualTo(Short value) {
            addCriterion("VSERSION >=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThan(Short value) {
            addCriterion("VSERSION <", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThanOrEqualTo(Short value) {
            addCriterion("VSERSION <=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionIn(List<Short> values) {
            addCriterion("VSERSION in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotIn(List<Short> values) {
            addCriterion("VSERSION not in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionBetween(Short value1, Short value2) {
            addCriterion("VSERSION between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotBetween(Short value1, Short value2) {
            addCriterion("VSERSION not between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNull() {
            addCriterion("IS_NEWEST is null");
            return (Criteria) this;
        }

        public Criteria andIsNewestIsNotNull() {
            addCriterion("IS_NEWEST is not null");
            return (Criteria) this;
        }

        public Criteria andIsNewestEqualTo(Short value) {
            addCriterion("IS_NEWEST =", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotEqualTo(Short value) {
            addCriterion("IS_NEWEST <>", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThan(Short value) {
            addCriterion("IS_NEWEST >", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestGreaterThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST >=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThan(Short value) {
            addCriterion("IS_NEWEST <", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestLessThanOrEqualTo(Short value) {
            addCriterion("IS_NEWEST <=", value, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestIn(List<Short> values) {
            addCriterion("IS_NEWEST in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotIn(List<Short> values) {
            addCriterion("IS_NEWEST not in", values, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andIsNewestNotBetween(Short value1, Short value2) {
            addCriterion("IS_NEWEST not between", value1, value2, "isNewest");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNull() {
            addCriterion("DATA_STATED is null");
            return (Criteria) this;
        }

        public Criteria andDataStatedIsNotNull() {
            addCriterion("DATA_STATED is not null");
            return (Criteria) this;
        }

        public Criteria andDataStatedEqualTo(String value) {
            addCriterion("DATA_STATED =", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotEqualTo(String value) {
            addCriterion("DATA_STATED <>", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThan(String value) {
            addCriterion("DATA_STATED >", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedGreaterThanOrEqualTo(String value) {
            addCriterion("DATA_STATED >=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThan(String value) {
            addCriterion("DATA_STATED <", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLessThanOrEqualTo(String value) {
            addCriterion("DATA_STATED <=", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedLike(String value) {
            addCriterion("DATA_STATED like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotLike(String value) {
            addCriterion("DATA_STATED not like", value, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedIn(List<String> values) {
            addCriterion("DATA_STATED in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotIn(List<String> values) {
            addCriterion("DATA_STATED not in", values, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedBetween(String value1, String value2) {
            addCriterion("DATA_STATED between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andDataStatedNotBetween(String value1, String value2) {
            addCriterion("DATA_STATED not between", value1, value2, "dataStated");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNull() {
            addCriterion("PIPE_LINE_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIsNotNull() {
            addCriterion("PIPE_LINE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdEqualTo(String value) {
            addCriterion("PIPE_LINE_ID =", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <>", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThan(String value) {
            addCriterion("PIPE_LINE_ID >", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID >=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThan(String value) {
            addCriterion("PIPE_LINE_ID <", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_LINE_ID <=", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdLike(String value) {
            addCriterion("PIPE_LINE_ID like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotLike(String value) {
            addCriterion("PIPE_LINE_ID not like", value, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdIn(List<String> values) {
            addCriterion("PIPE_LINE_ID in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotIn(List<String> values) {
            addCriterion("PIPE_LINE_ID not in", values, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeLineIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_LINE_ID not between", value1, value2, "pipeLineId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdIsNull() {
            addCriterion("PIPE_SEGMENT_ID is null");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdIsNotNull() {
            addCriterion("PIPE_SEGMENT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdEqualTo(String value) {
            addCriterion("PIPE_SEGMENT_ID =", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdNotEqualTo(String value) {
            addCriterion("PIPE_SEGMENT_ID <>", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdGreaterThan(String value) {
            addCriterion("PIPE_SEGMENT_ID >", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_SEGMENT_ID >=", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdLessThan(String value) {
            addCriterion("PIPE_SEGMENT_ID <", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdLessThanOrEqualTo(String value) {
            addCriterion("PIPE_SEGMENT_ID <=", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdLike(String value) {
            addCriterion("PIPE_SEGMENT_ID like", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdNotLike(String value) {
            addCriterion("PIPE_SEGMENT_ID not like", value, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdIn(List<String> values) {
            addCriterion("PIPE_SEGMENT_ID in", values, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdNotIn(List<String> values) {
            addCriterion("PIPE_SEGMENT_ID not in", values, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdBetween(String value1, String value2) {
            addCriterion("PIPE_SEGMENT_ID between", value1, value2, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andPipeSegmentIdNotBetween(String value1, String value2) {
            addCriterion("PIPE_SEGMENT_ID not between", value1, value2, "pipeSegmentId");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIsNull() {
            addCriterion("CUSTOM_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIsNotNull() {
            addCriterion("CUSTOM_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andCustomNumberEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER =", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER <>", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberGreaterThan(String value) {
            addCriterion("CUSTOM_NUMBER >", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER >=", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLessThan(String value) {
            addCriterion("CUSTOM_NUMBER <", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLessThanOrEqualTo(String value) {
            addCriterion("CUSTOM_NUMBER <=", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberLike(String value) {
            addCriterion("CUSTOM_NUMBER like", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotLike(String value) {
            addCriterion("CUSTOM_NUMBER not like", value, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberIn(List<String> values) {
            addCriterion("CUSTOM_NUMBER in", values, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotIn(List<String> values) {
            addCriterion("CUSTOM_NUMBER not in", values, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberBetween(String value1, String value2) {
            addCriterion("CUSTOM_NUMBER between", value1, value2, "customNumber");
            return (Criteria) this;
        }

        public Criteria andCustomNumberNotBetween(String value1, String value2) {
            addCriterion("CUSTOM_NUMBER not between", value1, value2, "customNumber");
            return (Criteria) this;
        }

        public Criteria andBeginPositionIsNull() {
            addCriterion("BEGIN_POSITION is null");
            return (Criteria) this;
        }

        public Criteria andBeginPositionIsNotNull() {
            addCriterion("BEGIN_POSITION is not null");
            return (Criteria) this;
        }

        public Criteria andBeginPositionEqualTo(String value) {
            addCriterion("BEGIN_POSITION =", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionNotEqualTo(String value) {
            addCriterion("BEGIN_POSITION <>", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionGreaterThan(String value) {
            addCriterion("BEGIN_POSITION >", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionGreaterThanOrEqualTo(String value) {
            addCriterion("BEGIN_POSITION >=", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionLessThan(String value) {
            addCriterion("BEGIN_POSITION <", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionLessThanOrEqualTo(String value) {
            addCriterion("BEGIN_POSITION <=", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionLike(String value) {
            addCriterion("BEGIN_POSITION like", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionNotLike(String value) {
            addCriterion("BEGIN_POSITION not like", value, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionIn(List<String> values) {
            addCriterion("BEGIN_POSITION in", values, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionNotIn(List<String> values) {
            addCriterion("BEGIN_POSITION not in", values, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionBetween(String value1, String value2) {
            addCriterion("BEGIN_POSITION between", value1, value2, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andBeginPositionNotBetween(String value1, String value2) {
            addCriterion("BEGIN_POSITION not between", value1, value2, "beginPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionIsNull() {
            addCriterion("END_POSITION is null");
            return (Criteria) this;
        }

        public Criteria andEndPositionIsNotNull() {
            addCriterion("END_POSITION is not null");
            return (Criteria) this;
        }

        public Criteria andEndPositionEqualTo(String value) {
            addCriterion("END_POSITION =", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionNotEqualTo(String value) {
            addCriterion("END_POSITION <>", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionGreaterThan(String value) {
            addCriterion("END_POSITION >", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionGreaterThanOrEqualTo(String value) {
            addCriterion("END_POSITION >=", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionLessThan(String value) {
            addCriterion("END_POSITION <", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionLessThanOrEqualTo(String value) {
            addCriterion("END_POSITION <=", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionLike(String value) {
            addCriterion("END_POSITION like", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionNotLike(String value) {
            addCriterion("END_POSITION not like", value, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionIn(List<String> values) {
            addCriterion("END_POSITION in", values, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionNotIn(List<String> values) {
            addCriterion("END_POSITION not in", values, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionBetween(String value1, String value2) {
            addCriterion("END_POSITION between", value1, value2, "endPosition");
            return (Criteria) this;
        }

        public Criteria andEndPositionNotBetween(String value1, String value2) {
            addCriterion("END_POSITION not between", value1, value2, "endPosition");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeIsNull() {
            addCriterion("PIPELINE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeIsNotNull() {
            addCriterion("PIPELINE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeEqualTo(String value) {
            addCriterion("PIPELINE_TYPE =", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeNotEqualTo(String value) {
            addCriterion("PIPELINE_TYPE <>", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeGreaterThan(String value) {
            addCriterion("PIPELINE_TYPE >", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PIPELINE_TYPE >=", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeLessThan(String value) {
            addCriterion("PIPELINE_TYPE <", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeLessThanOrEqualTo(String value) {
            addCriterion("PIPELINE_TYPE <=", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeLike(String value) {
            addCriterion("PIPELINE_TYPE like", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeNotLike(String value) {
            addCriterion("PIPELINE_TYPE not like", value, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeIn(List<String> values) {
            addCriterion("PIPELINE_TYPE in", values, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeNotIn(List<String> values) {
            addCriterion("PIPELINE_TYPE not in", values, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeBetween(String value1, String value2) {
            addCriterion("PIPELINE_TYPE between", value1, value2, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andPipelineTypeNotBetween(String value1, String value2) {
            addCriterion("PIPELINE_TYPE not between", value1, value2, "pipelineType");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeIsNull() {
            addCriterion("INSERVICE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeIsNotNull() {
            addCriterion("INSERVICE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeEqualTo(Date value) {
            addCriterion("INSERVICE_TIME =", value, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeNotEqualTo(Date value) {
            addCriterion("INSERVICE_TIME <>", value, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeGreaterThan(Date value) {
            addCriterion("INSERVICE_TIME >", value, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("INSERVICE_TIME >=", value, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeLessThan(Date value) {
            addCriterion("INSERVICE_TIME <", value, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeLessThanOrEqualTo(Date value) {
            addCriterion("INSERVICE_TIME <=", value, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeIn(List<Date> values) {
            addCriterion("INSERVICE_TIME in", values, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeNotIn(List<Date> values) {
            addCriterion("INSERVICE_TIME not in", values, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeBetween(Date value1, Date value2) {
            addCriterion("INSERVICE_TIME between", value1, value2, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andInserviceTimeNotBetween(Date value1, Date value2) {
            addCriterion("INSERVICE_TIME not between", value1, value2, "inserviceTime");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusIsNull() {
            addCriterion("OPERATIONAL_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusIsNotNull() {
            addCriterion("OPERATIONAL_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusEqualTo(String value) {
            addCriterion("OPERATIONAL_STATUS =", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusNotEqualTo(String value) {
            addCriterion("OPERATIONAL_STATUS <>", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusGreaterThan(String value) {
            addCriterion("OPERATIONAL_STATUS >", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusGreaterThanOrEqualTo(String value) {
            addCriterion("OPERATIONAL_STATUS >=", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusLessThan(String value) {
            addCriterion("OPERATIONAL_STATUS <", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusLessThanOrEqualTo(String value) {
            addCriterion("OPERATIONAL_STATUS <=", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusLike(String value) {
            addCriterion("OPERATIONAL_STATUS like", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusNotLike(String value) {
            addCriterion("OPERATIONAL_STATUS not like", value, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusIn(List<String> values) {
            addCriterion("OPERATIONAL_STATUS in", values, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusNotIn(List<String> values) {
            addCriterion("OPERATIONAL_STATUS not in", values, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusBetween(String value1, String value2) {
            addCriterion("OPERATIONAL_STATUS between", value1, value2, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andOperationalStatusNotBetween(String value1, String value2) {
            addCriterion("OPERATIONAL_STATUS not between", value1, value2, "operationalStatus");
            return (Criteria) this;
        }

        public Criteria andDesignLengthIsNull() {
            addCriterion("DESIGN_LENGTH is null");
            return (Criteria) this;
        }

        public Criteria andDesignLengthIsNotNull() {
            addCriterion("DESIGN_LENGTH is not null");
            return (Criteria) this;
        }

        public Criteria andDesignLengthEqualTo(BigDecimal value) {
            addCriterion("DESIGN_LENGTH =", value, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthNotEqualTo(BigDecimal value) {
            addCriterion("DESIGN_LENGTH <>", value, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthGreaterThan(BigDecimal value) {
            addCriterion("DESIGN_LENGTH >", value, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DESIGN_LENGTH >=", value, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthLessThan(BigDecimal value) {
            addCriterion("DESIGN_LENGTH <", value, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DESIGN_LENGTH <=", value, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthIn(List<BigDecimal> values) {
            addCriterion("DESIGN_LENGTH in", values, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthNotIn(List<BigDecimal> values) {
            addCriterion("DESIGN_LENGTH not in", values, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DESIGN_LENGTH between", value1, value2, "designLength");
            return (Criteria) this;
        }

        public Criteria andDesignLengthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DESIGN_LENGTH not between", value1, value2, "designLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthIsNull() {
            addCriterion("COUNT_LENGTH is null");
            return (Criteria) this;
        }

        public Criteria andCountLengthIsNotNull() {
            addCriterion("COUNT_LENGTH is not null");
            return (Criteria) this;
        }

        public Criteria andCountLengthEqualTo(BigDecimal value) {
            addCriterion("COUNT_LENGTH =", value, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthNotEqualTo(BigDecimal value) {
            addCriterion("COUNT_LENGTH <>", value, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthGreaterThan(BigDecimal value) {
            addCriterion("COUNT_LENGTH >", value, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("COUNT_LENGTH >=", value, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthLessThan(BigDecimal value) {
            addCriterion("COUNT_LENGTH <", value, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("COUNT_LENGTH <=", value, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthIn(List<BigDecimal> values) {
            addCriterion("COUNT_LENGTH in", values, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthNotIn(List<BigDecimal> values) {
            addCriterion("COUNT_LENGTH not in", values, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COUNT_LENGTH between", value1, value2, "countLength");
            return (Criteria) this;
        }

        public Criteria andCountLengthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COUNT_LENGTH not between", value1, value2, "countLength");
            return (Criteria) this;
        }

        public Criteria andDiameterIsNull() {
            addCriterion("DIAMETER is null");
            return (Criteria) this;
        }

        public Criteria andDiameterIsNotNull() {
            addCriterion("DIAMETER is not null");
            return (Criteria) this;
        }

        public Criteria andDiameterEqualTo(String value) {
            addCriterion("DIAMETER =", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotEqualTo(String value) {
            addCriterion("DIAMETER <>", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterGreaterThan(String value) {
            addCriterion("DIAMETER >", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterGreaterThanOrEqualTo(String value) {
            addCriterion("DIAMETER >=", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLessThan(String value) {
            addCriterion("DIAMETER <", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLessThanOrEqualTo(String value) {
            addCriterion("DIAMETER <=", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLike(String value) {
            addCriterion("DIAMETER like", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotLike(String value) {
            addCriterion("DIAMETER not like", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterIn(List<String> values) {
            addCriterion("DIAMETER in", values, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotIn(List<String> values) {
            addCriterion("DIAMETER not in", values, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterBetween(String value1, String value2) {
            addCriterion("DIAMETER between", value1, value2, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotBetween(String value1, String value2) {
            addCriterion("DIAMETER not between", value1, value2, "diameter");
            return (Criteria) this;
        }

        public Criteria andWallthicknessIsNull() {
            addCriterion("WALLTHICKNESS is null");
            return (Criteria) this;
        }

        public Criteria andWallthicknessIsNotNull() {
            addCriterion("WALLTHICKNESS is not null");
            return (Criteria) this;
        }

        public Criteria andWallthicknessEqualTo(BigDecimal value) {
            addCriterion("WALLTHICKNESS =", value, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessNotEqualTo(BigDecimal value) {
            addCriterion("WALLTHICKNESS <>", value, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessGreaterThan(BigDecimal value) {
            addCriterion("WALLTHICKNESS >", value, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WALLTHICKNESS >=", value, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessLessThan(BigDecimal value) {
            addCriterion("WALLTHICKNESS <", value, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WALLTHICKNESS <=", value, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessIn(List<BigDecimal> values) {
            addCriterion("WALLTHICKNESS in", values, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessNotIn(List<BigDecimal> values) {
            addCriterion("WALLTHICKNESS not in", values, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WALLTHICKNESS between", value1, value2, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andWallthicknessNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WALLTHICKNESS not between", value1, value2, "wallthickness");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNull() {
            addCriterion("MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNotNull() {
            addCriterion("MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialEqualTo(String value) {
            addCriterion("MATERIAL =", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotEqualTo(String value) {
            addCriterion("MATERIAL <>", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThan(String value) {
            addCriterion("MATERIAL >", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL >=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThan(String value) {
            addCriterion("MATERIAL <", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL <=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLike(String value) {
            addCriterion("MATERIAL like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotLike(String value) {
            addCriterion("MATERIAL not like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialIn(List<String> values) {
            addCriterion("MATERIAL in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotIn(List<String> values) {
            addCriterion("MATERIAL not in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialBetween(String value1, String value2) {
            addCriterion("MATERIAL between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotBetween(String value1, String value2) {
            addCriterion("MATERIAL not between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialIsNull() {
            addCriterion("COATINGMATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialIsNotNull() {
            addCriterion("COATINGMATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialEqualTo(String value) {
            addCriterion("COATINGMATERIAL =", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialNotEqualTo(String value) {
            addCriterion("COATINGMATERIAL <>", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialGreaterThan(String value) {
            addCriterion("COATINGMATERIAL >", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialGreaterThanOrEqualTo(String value) {
            addCriterion("COATINGMATERIAL >=", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialLessThan(String value) {
            addCriterion("COATINGMATERIAL <", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialLessThanOrEqualTo(String value) {
            addCriterion("COATINGMATERIAL <=", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialLike(String value) {
            addCriterion("COATINGMATERIAL like", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialNotLike(String value) {
            addCriterion("COATINGMATERIAL not like", value, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialIn(List<String> values) {
            addCriterion("COATINGMATERIAL in", values, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialNotIn(List<String> values) {
            addCriterion("COATINGMATERIAL not in", values, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialBetween(String value1, String value2) {
            addCriterion("COATINGMATERIAL between", value1, value2, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingmaterialNotBetween(String value1, String value2) {
            addCriterion("COATINGMATERIAL not between", value1, value2, "coatingmaterial");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeIsNull() {
            addCriterion("MANUPIPE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeIsNotNull() {
            addCriterion("MANUPIPE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeEqualTo(String value) {
            addCriterion("MANUPIPE_TYPE =", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeNotEqualTo(String value) {
            addCriterion("MANUPIPE_TYPE <>", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeGreaterThan(String value) {
            addCriterion("MANUPIPE_TYPE >", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeGreaterThanOrEqualTo(String value) {
            addCriterion("MANUPIPE_TYPE >=", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeLessThan(String value) {
            addCriterion("MANUPIPE_TYPE <", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeLessThanOrEqualTo(String value) {
            addCriterion("MANUPIPE_TYPE <=", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeLike(String value) {
            addCriterion("MANUPIPE_TYPE like", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeNotLike(String value) {
            addCriterion("MANUPIPE_TYPE not like", value, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeIn(List<String> values) {
            addCriterion("MANUPIPE_TYPE in", values, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeNotIn(List<String> values) {
            addCriterion("MANUPIPE_TYPE not in", values, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeBetween(String value1, String value2) {
            addCriterion("MANUPIPE_TYPE between", value1, value2, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andManupipeTypeNotBetween(String value1, String value2) {
            addCriterion("MANUPIPE_TYPE not between", value1, value2, "manupipeType");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeIsNull() {
            addCriterion("COATING_GRADE is null");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeIsNotNull() {
            addCriterion("COATING_GRADE is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeEqualTo(String value) {
            addCriterion("COATING_GRADE =", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotEqualTo(String value) {
            addCriterion("COATING_GRADE <>", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeGreaterThan(String value) {
            addCriterion("COATING_GRADE >", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_GRADE >=", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeLessThan(String value) {
            addCriterion("COATING_GRADE <", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeLessThanOrEqualTo(String value) {
            addCriterion("COATING_GRADE <=", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeLike(String value) {
            addCriterion("COATING_GRADE like", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotLike(String value) {
            addCriterion("COATING_GRADE not like", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeIn(List<String> values) {
            addCriterion("COATING_GRADE in", values, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotIn(List<String> values) {
            addCriterion("COATING_GRADE not in", values, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeBetween(String value1, String value2) {
            addCriterion("COATING_GRADE between", value1, value2, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotBetween(String value1, String value2) {
            addCriterion("COATING_GRADE not between", value1, value2, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andJointMaterialIsNull() {
            addCriterion("JOINT_MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andJointMaterialIsNotNull() {
            addCriterion("JOINT_MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andJointMaterialEqualTo(String value) {
            addCriterion("JOINT_MATERIAL =", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialNotEqualTo(String value) {
            addCriterion("JOINT_MATERIAL <>", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialGreaterThan(String value) {
            addCriterion("JOINT_MATERIAL >", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("JOINT_MATERIAL >=", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialLessThan(String value) {
            addCriterion("JOINT_MATERIAL <", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialLessThanOrEqualTo(String value) {
            addCriterion("JOINT_MATERIAL <=", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialLike(String value) {
            addCriterion("JOINT_MATERIAL like", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialNotLike(String value) {
            addCriterion("JOINT_MATERIAL not like", value, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialIn(List<String> values) {
            addCriterion("JOINT_MATERIAL in", values, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialNotIn(List<String> values) {
            addCriterion("JOINT_MATERIAL not in", values, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialBetween(String value1, String value2) {
            addCriterion("JOINT_MATERIAL between", value1, value2, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andJointMaterialNotBetween(String value1, String value2) {
            addCriterion("JOINT_MATERIAL not between", value1, value2, "jointMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialIsNull() {
            addCriterion("INCOATING_MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialIsNotNull() {
            addCriterion("INCOATING_MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialEqualTo(String value) {
            addCriterion("INCOATING_MATERIAL =", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialNotEqualTo(String value) {
            addCriterion("INCOATING_MATERIAL <>", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialGreaterThan(String value) {
            addCriterion("INCOATING_MATERIAL >", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("INCOATING_MATERIAL >=", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialLessThan(String value) {
            addCriterion("INCOATING_MATERIAL <", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialLessThanOrEqualTo(String value) {
            addCriterion("INCOATING_MATERIAL <=", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialLike(String value) {
            addCriterion("INCOATING_MATERIAL like", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialNotLike(String value) {
            addCriterion("INCOATING_MATERIAL not like", value, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialIn(List<String> values) {
            addCriterion("INCOATING_MATERIAL in", values, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialNotIn(List<String> values) {
            addCriterion("INCOATING_MATERIAL not in", values, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialBetween(String value1, String value2) {
            addCriterion("INCOATING_MATERIAL between", value1, value2, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andIncoatingMaterialNotBetween(String value1, String value2) {
            addCriterion("INCOATING_MATERIAL not between", value1, value2, "incoatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCpTypeIsNull() {
            addCriterion("CP_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCpTypeIsNotNull() {
            addCriterion("CP_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCpTypeEqualTo(String value) {
            addCriterion("CP_TYPE =", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeNotEqualTo(String value) {
            addCriterion("CP_TYPE <>", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeGreaterThan(String value) {
            addCriterion("CP_TYPE >", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CP_TYPE >=", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeLessThan(String value) {
            addCriterion("CP_TYPE <", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeLessThanOrEqualTo(String value) {
            addCriterion("CP_TYPE <=", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeLike(String value) {
            addCriterion("CP_TYPE like", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeNotLike(String value) {
            addCriterion("CP_TYPE not like", value, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeIn(List<String> values) {
            addCriterion("CP_TYPE in", values, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeNotIn(List<String> values) {
            addCriterion("CP_TYPE not in", values, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeBetween(String value1, String value2) {
            addCriterion("CP_TYPE between", value1, value2, "cpType");
            return (Criteria) this;
        }

        public Criteria andCpTypeNotBetween(String value1, String value2) {
            addCriterion("CP_TYPE not between", value1, value2, "cpType");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearIsNull() {
            addCriterion("DESIGN_TRAN_YEAR is null");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearIsNotNull() {
            addCriterion("DESIGN_TRAN_YEAR is not null");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearEqualTo(BigDecimal value) {
            addCriterion("DESIGN_TRAN_YEAR =", value, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearNotEqualTo(BigDecimal value) {
            addCriterion("DESIGN_TRAN_YEAR <>", value, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearGreaterThan(BigDecimal value) {
            addCriterion("DESIGN_TRAN_YEAR >", value, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("DESIGN_TRAN_YEAR >=", value, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearLessThan(BigDecimal value) {
            addCriterion("DESIGN_TRAN_YEAR <", value, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearLessThanOrEqualTo(BigDecimal value) {
            addCriterion("DESIGN_TRAN_YEAR <=", value, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearIn(List<BigDecimal> values) {
            addCriterion("DESIGN_TRAN_YEAR in", values, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearNotIn(List<BigDecimal> values) {
            addCriterion("DESIGN_TRAN_YEAR not in", values, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DESIGN_TRAN_YEAR between", value1, value2, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andDesignTranYearNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("DESIGN_TRAN_YEAR not between", value1, value2, "designTranYear");
            return (Criteria) this;
        }

        public Criteria andPressureRatingIsNull() {
            addCriterion("PRESSURE_RATING is null");
            return (Criteria) this;
        }

        public Criteria andPressureRatingIsNotNull() {
            addCriterion("PRESSURE_RATING is not null");
            return (Criteria) this;
        }

        public Criteria andPressureRatingEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING =", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingNotEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING <>", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingGreaterThan(BigDecimal value) {
            addCriterion("PRESSURE_RATING >", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING >=", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingLessThan(BigDecimal value) {
            addCriterion("PRESSURE_RATING <", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PRESSURE_RATING <=", value, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingIn(List<BigDecimal> values) {
            addCriterion("PRESSURE_RATING in", values, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingNotIn(List<BigDecimal> values) {
            addCriterion("PRESSURE_RATING not in", values, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRESSURE_RATING between", value1, value2, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andPressureRatingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PRESSURE_RATING not between", value1, value2, "pressureRating");
            return (Criteria) this;
        }

        public Criteria andMediumTypeIsNull() {
            addCriterion("MEDIUM_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andMediumTypeIsNotNull() {
            addCriterion("MEDIUM_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andMediumTypeEqualTo(String value) {
            addCriterion("MEDIUM_TYPE =", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeNotEqualTo(String value) {
            addCriterion("MEDIUM_TYPE <>", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeGreaterThan(String value) {
            addCriterion("MEDIUM_TYPE >", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeGreaterThanOrEqualTo(String value) {
            addCriterion("MEDIUM_TYPE >=", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeLessThan(String value) {
            addCriterion("MEDIUM_TYPE <", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeLessThanOrEqualTo(String value) {
            addCriterion("MEDIUM_TYPE <=", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeLike(String value) {
            addCriterion("MEDIUM_TYPE like", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeNotLike(String value) {
            addCriterion("MEDIUM_TYPE not like", value, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeIn(List<String> values) {
            addCriterion("MEDIUM_TYPE in", values, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeNotIn(List<String> values) {
            addCriterion("MEDIUM_TYPE not in", values, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeBetween(String value1, String value2) {
            addCriterion("MEDIUM_TYPE between", value1, value2, "mediumType");
            return (Criteria) this;
        }

        public Criteria andMediumTypeNotBetween(String value1, String value2) {
            addCriterion("MEDIUM_TYPE not between", value1, value2, "mediumType");
            return (Criteria) this;
        }

        public Criteria andDryOrWetIsNull() {
            addCriterion("DRY_OR_WET is null");
            return (Criteria) this;
        }

        public Criteria andDryOrWetIsNotNull() {
            addCriterion("DRY_OR_WET is not null");
            return (Criteria) this;
        }

        public Criteria andDryOrWetEqualTo(String value) {
            addCriterion("DRY_OR_WET =", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetNotEqualTo(String value) {
            addCriterion("DRY_OR_WET <>", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetGreaterThan(String value) {
            addCriterion("DRY_OR_WET >", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetGreaterThanOrEqualTo(String value) {
            addCriterion("DRY_OR_WET >=", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetLessThan(String value) {
            addCriterion("DRY_OR_WET <", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetLessThanOrEqualTo(String value) {
            addCriterion("DRY_OR_WET <=", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetLike(String value) {
            addCriterion("DRY_OR_WET like", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetNotLike(String value) {
            addCriterion("DRY_OR_WET not like", value, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetIn(List<String> values) {
            addCriterion("DRY_OR_WET in", values, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetNotIn(List<String> values) {
            addCriterion("DRY_OR_WET not in", values, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetBetween(String value1, String value2) {
            addCriterion("DRY_OR_WET between", value1, value2, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andDryOrWetNotBetween(String value1, String value2) {
            addCriterion("DRY_OR_WET not between", value1, value2, "dryOrWet");
            return (Criteria) this;
        }

        public Criteria andH2sIsNull() {
            addCriterion("H2S is null");
            return (Criteria) this;
        }

        public Criteria andH2sIsNotNull() {
            addCriterion("H2S is not null");
            return (Criteria) this;
        }

        public Criteria andH2sEqualTo(String value) {
            addCriterion("H2S =", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sNotEqualTo(String value) {
            addCriterion("H2S <>", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sGreaterThan(String value) {
            addCriterion("H2S >", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sGreaterThanOrEqualTo(String value) {
            addCriterion("H2S >=", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sLessThan(String value) {
            addCriterion("H2S <", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sLessThanOrEqualTo(String value) {
            addCriterion("H2S <=", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sLike(String value) {
            addCriterion("H2S like", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sNotLike(String value) {
            addCriterion("H2S not like", value, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sIn(List<String> values) {
            addCriterion("H2S in", values, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sNotIn(List<String> values) {
            addCriterion("H2S not in", values, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sBetween(String value1, String value2) {
            addCriterion("H2S between", value1, value2, "h2s");
            return (Criteria) this;
        }

        public Criteria andH2sNotBetween(String value1, String value2) {
            addCriterion("H2S not between", value1, value2, "h2s");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionIsNull() {
            addCriterion("PIPE_FUNCTION is null");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionIsNotNull() {
            addCriterion("PIPE_FUNCTION is not null");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionEqualTo(String value) {
            addCriterion("PIPE_FUNCTION =", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionNotEqualTo(String value) {
            addCriterion("PIPE_FUNCTION <>", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionGreaterThan(String value) {
            addCriterion("PIPE_FUNCTION >", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionGreaterThanOrEqualTo(String value) {
            addCriterion("PIPE_FUNCTION >=", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionLessThan(String value) {
            addCriterion("PIPE_FUNCTION <", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionLessThanOrEqualTo(String value) {
            addCriterion("PIPE_FUNCTION <=", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionLike(String value) {
            addCriterion("PIPE_FUNCTION like", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionNotLike(String value) {
            addCriterion("PIPE_FUNCTION not like", value, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionIn(List<String> values) {
            addCriterion("PIPE_FUNCTION in", values, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionNotIn(List<String> values) {
            addCriterion("PIPE_FUNCTION not in", values, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionBetween(String value1, String value2) {
            addCriterion("PIPE_FUNCTION between", value1, value2, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andPipeFunctionNotBetween(String value1, String value2) {
            addCriterion("PIPE_FUNCTION not between", value1, value2, "pipeFunction");
            return (Criteria) this;
        }

        public Criteria andDesignUnitIsNull() {
            addCriterion("DESIGN_UNIT is null");
            return (Criteria) this;
        }

        public Criteria andDesignUnitIsNotNull() {
            addCriterion("DESIGN_UNIT is not null");
            return (Criteria) this;
        }

        public Criteria andDesignUnitEqualTo(String value) {
            addCriterion("DESIGN_UNIT =", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitNotEqualTo(String value) {
            addCriterion("DESIGN_UNIT <>", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitGreaterThan(String value) {
            addCriterion("DESIGN_UNIT >", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitGreaterThanOrEqualTo(String value) {
            addCriterion("DESIGN_UNIT >=", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitLessThan(String value) {
            addCriterion("DESIGN_UNIT <", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitLessThanOrEqualTo(String value) {
            addCriterion("DESIGN_UNIT <=", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitLike(String value) {
            addCriterion("DESIGN_UNIT like", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitNotLike(String value) {
            addCriterion("DESIGN_UNIT not like", value, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitIn(List<String> values) {
            addCriterion("DESIGN_UNIT in", values, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitNotIn(List<String> values) {
            addCriterion("DESIGN_UNIT not in", values, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitBetween(String value1, String value2) {
            addCriterion("DESIGN_UNIT between", value1, value2, "designUnit");
            return (Criteria) this;
        }

        public Criteria andDesignUnitNotBetween(String value1, String value2) {
            addCriterion("DESIGN_UNIT not between", value1, value2, "designUnit");
            return (Criteria) this;
        }

        public Criteria andConstrucionIsNull() {
            addCriterion("CONSTRUCION is null");
            return (Criteria) this;
        }

        public Criteria andConstrucionIsNotNull() {
            addCriterion("CONSTRUCION is not null");
            return (Criteria) this;
        }

        public Criteria andConstrucionEqualTo(String value) {
            addCriterion("CONSTRUCION =", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionNotEqualTo(String value) {
            addCriterion("CONSTRUCION <>", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionGreaterThan(String value) {
            addCriterion("CONSTRUCION >", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionGreaterThanOrEqualTo(String value) {
            addCriterion("CONSTRUCION >=", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionLessThan(String value) {
            addCriterion("CONSTRUCION <", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionLessThanOrEqualTo(String value) {
            addCriterion("CONSTRUCION <=", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionLike(String value) {
            addCriterion("CONSTRUCION like", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionNotLike(String value) {
            addCriterion("CONSTRUCION not like", value, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionIn(List<String> values) {
            addCriterion("CONSTRUCION in", values, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionNotIn(List<String> values) {
            addCriterion("CONSTRUCION not in", values, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionBetween(String value1, String value2) {
            addCriterion("CONSTRUCION between", value1, value2, "construcion");
            return (Criteria) this;
        }

        public Criteria andConstrucionNotBetween(String value1, String value2) {
            addCriterion("CONSTRUCION not between", value1, value2, "construcion");
            return (Criteria) this;
        }

        public Criteria andSupervisionIsNull() {
            addCriterion("SUPERVISION is null");
            return (Criteria) this;
        }

        public Criteria andSupervisionIsNotNull() {
            addCriterion("SUPERVISION is not null");
            return (Criteria) this;
        }

        public Criteria andSupervisionEqualTo(String value) {
            addCriterion("SUPERVISION =", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionNotEqualTo(String value) {
            addCriterion("SUPERVISION <>", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionGreaterThan(String value) {
            addCriterion("SUPERVISION >", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionGreaterThanOrEqualTo(String value) {
            addCriterion("SUPERVISION >=", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionLessThan(String value) {
            addCriterion("SUPERVISION <", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionLessThanOrEqualTo(String value) {
            addCriterion("SUPERVISION <=", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionLike(String value) {
            addCriterion("SUPERVISION like", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionNotLike(String value) {
            addCriterion("SUPERVISION not like", value, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionIn(List<String> values) {
            addCriterion("SUPERVISION in", values, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionNotIn(List<String> values) {
            addCriterion("SUPERVISION not in", values, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionBetween(String value1, String value2) {
            addCriterion("SUPERVISION between", value1, value2, "supervision");
            return (Criteria) this;
        }

        public Criteria andSupervisionNotBetween(String value1, String value2) {
            addCriterion("SUPERVISION not between", value1, value2, "supervision");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIsNull() {
            addCriterion("TESTING_COMPANY is null");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIsNotNull() {
            addCriterion("TESTING_COMPANY is not null");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyEqualTo(String value) {
            addCriterion("TESTING_COMPANY =", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotEqualTo(String value) {
            addCriterion("TESTING_COMPANY <>", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyGreaterThan(String value) {
            addCriterion("TESTING_COMPANY >", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("TESTING_COMPANY >=", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLessThan(String value) {
            addCriterion("TESTING_COMPANY <", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLessThanOrEqualTo(String value) {
            addCriterion("TESTING_COMPANY <=", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyLike(String value) {
            addCriterion("TESTING_COMPANY like", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotLike(String value) {
            addCriterion("TESTING_COMPANY not like", value, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyIn(List<String> values) {
            addCriterion("TESTING_COMPANY in", values, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotIn(List<String> values) {
            addCriterion("TESTING_COMPANY not in", values, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyBetween(String value1, String value2) {
            addCriterion("TESTING_COMPANY between", value1, value2, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andTestingCompanyNotBetween(String value1, String value2) {
            addCriterion("TESTING_COMPANY not between", value1, value2, "testingCompany");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNull() {
            addCriterion("RECORDER is null");
            return (Criteria) this;
        }

        public Criteria andRecorderIsNotNull() {
            addCriterion("RECORDER is not null");
            return (Criteria) this;
        }

        public Criteria andRecorderEqualTo(String value) {
            addCriterion("RECORDER =", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotEqualTo(String value) {
            addCriterion("RECORDER <>", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThan(String value) {
            addCriterion("RECORDER >", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderGreaterThanOrEqualTo(String value) {
            addCriterion("RECORDER >=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThan(String value) {
            addCriterion("RECORDER <", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLessThanOrEqualTo(String value) {
            addCriterion("RECORDER <=", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderLike(String value) {
            addCriterion("RECORDER like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotLike(String value) {
            addCriterion("RECORDER not like", value, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderIn(List<String> values) {
            addCriterion("RECORDER in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotIn(List<String> values) {
            addCriterion("RECORDER not in", values, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderBetween(String value1, String value2) {
            addCriterion("RECORDER between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecorderNotBetween(String value1, String value2) {
            addCriterion("RECORDER not between", value1, value2, "recorder");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIsNull() {
            addCriterion("RECORDTIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIsNotNull() {
            addCriterion("RECORDTIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordtimeEqualTo(Date value) {
            addCriterion("RECORDTIME =", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotEqualTo(Date value) {
            addCriterion("RECORDTIME <>", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeGreaterThan(Date value) {
            addCriterion("RECORDTIME >", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORDTIME >=", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeLessThan(Date value) {
            addCriterion("RECORDTIME <", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORDTIME <=", value, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeIn(List<Date> values) {
            addCriterion("RECORDTIME in", values, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotIn(List<Date> values) {
            addCriterion("RECORDTIME not in", values, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeBetween(Date value1, Date value2) {
            addCriterion("RECORDTIME between", value1, value2, "recordtime");
            return (Criteria) this;
        }

        public Criteria andRecordtimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORDTIME not between", value1, value2, "recordtime");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNull() {
            addCriterion("ORG_BIZ_PATH is null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIsNotNull() {
            addCriterion("ORG_BIZ_PATH is not null");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH =", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <>", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThan(String value) {
            addCriterion("ORG_BIZ_PATH >", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH >=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThan(String value) {
            addCriterion("ORG_BIZ_PATH <", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLessThanOrEqualTo(String value) {
            addCriterion("ORG_BIZ_PATH <=", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathLike(String value) {
            addCriterion("ORG_BIZ_PATH like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotLike(String value) {
            addCriterion("ORG_BIZ_PATH not like", value, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotIn(List<String> values) {
            addCriterion("ORG_BIZ_PATH not in", values, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }

        public Criteria andOrgBizPathNotBetween(String value1, String value2) {
            addCriterion("ORG_BIZ_PATH not between", value1, value2, "orgBizPath");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}